{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# apacheApsVar, apachePredVar, apachePatientResult\n",
    "\n",
    "These three tables are used to document data relating to the APACHE IV / APACHE IVa systems. These systems provide predictions for in-hospital mortality, length of stay, length of mechanical ventilation, among others. The data used to create these predictions is stored in the apacheApsVar and apachePredVar tables. The result of the predictions, along with the observed outcome, is stored in the apachePatientResult table.\n",
    "\n",
    "## History of APACHE\n",
    "\n",
    "Acute Physiology Age Chronic Health Evaluation (APACHE) consists of a groups of equations used for predicting outcomes in critically ill patients. APACHE II is based on the APS or acute physiology score (which uses 12 physiologic values), age, and chronic health status within one of 56 disease groups. APACHE II is no longer considered valid due to inadequate case mix index adjustments and over estimates mortality because it is based on models from the 1970s-1980s. APACHE III, introduced in 1991, improved the equation by changing the number and weights of the APS and revising the measurement of chronic health status. APACHE IVa further improved the equations and has been described as having the highest discrimination of any other adult risk adjustment model (SAPS 3, SOFA, MPM III).\n",
    "\n",
    "Practically, this means:\n",
    "\n",
    "1. The `acutePhysiologyScore` calculated and provided is identical to that published with APACHE III, i.e. it is the Acute Physiology Score (APS) III. There is no such thing as an APS IV.\n",
    "2. The `apacheScore` calculated and provided is identical to that published with APACHE III.\n",
    "3. The final prediction, e.g. `predictedHospitalMortality`, is the output of the APACHE IV or APACHE IVa model, respectively, and uses the `apacheScore` as an input. The `apacheScore` in turn uses the `acutePhysiologyScore` as an input.\n",
    "\n",
    "## Using the tables\n",
    "\n",
    "If you are interested in the underlying data, the apacheApsVar and apachePredVar have the physiology and other covariates which drive the APACHE predictions. These tables have one row per `patientUnitStayId`.\n",
    "\n",
    "If you are interested in the predictions and/or outcomes for the patients, the apachePatientResult table contains this data. **The apachePatientResult table contains two rows per `patientUnitStayId`**: one for APACHE IV, and one for APACHE IVa."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## apachePatientResult\n",
    "\n",
    "`physicianSpeciality` | varchar(50) | NULL | Physician Specialty picklist value |  | S\n",
    "`physicianInterventionCategory` | varchar(50) | NULL | Physician Intervention Category picklist value |  | S\n",
    "`acutePhysiologyScore` | int | NULL | Acute Physiology Score from Apache API |  | S\n",
    "`apacheScore` | int | NULL | Apache Score. Calculated from acutePhysiologyScore |  | S\n",
    "`apacheVersion` | tinyint | NOT NULL | The version of the APACHE algorithm used to produce the apacheScore (e.g 3, 4) |  | S\n",
    "`predictedICUMortality` | varchar(50) | NULL | Predicted ICU Mortality from Apache API |  | S\n",
    "`actualICUMortality` | varchar(50) | NULL | Actual ICU Mortality |  | S\n",
    "`predictedICULOS` | float(53) | NULL | Predicted ICU Length of Stay from Apache API |  | S\n",
    "`actualICULOS` | float(53) | NULL | Actual ICU Length of Stay |  | S\n",
    "`predictedHospitalMortality` | varchar(50) | NULL | Predicted Hospital Mortality from Apache API |  | S\n",
    "`actualHospitalMortality` | varchar(50) | NULL | Actual Hospital Mortality |  | S\n",
    "`predictedHospitalLOS` | float(53) | NULL | Predicted Hospital Length of Stay from Apache API |  | S\n",
    "`actualHospitalLOS` | float(53) | NULL | Actual Hospital Length of Stay. Value is 50 when when > 50 days. |  | S\n",
    "`preopMI` | int | NULL | Indicates if patient has pre –Operative Myocardial Infarction |  | S\n",
    "`preopCardiacCath` | int | NULL | Indicates if patient has pre –Operative cardiac catheterization |  | S\n",
    "`PTCAwithin24h` | int | NULL | 0/1. 1- Patient had PTCA with 24 hrs |  | S\n",
    "`unabridgedUnitLOS` | float(53) | NULL | Actual ICU Length of stay |  | S\n",
    "`unabridgedHospLOS` | float(53) | NULL | Actual Hospital Length of stay |  | S\n",
    "`actualVentdays` | float(53) | NULL | Actual Ventilation days. Value is 30 when Actual Ventilation > 30 |  | S\n",
    "`predVentdays` | float(53) | NULL | Predicted ventilation days from Apache API |  | S\n",
    "`unabridgedActualVentdays` | float(53) | NULL | Actual Ventilation days |  | S\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/alistairewj/.local/lib/python3.5/site-packages/psycopg2/__init__.py:144: UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use \"pip install psycopg2-binary\" instead. For details see: <http://initd.org/psycopg/docs/install.html#binary-install-from-pypi>.\n",
      "  \"\"\")\n"
     ]
    }
   ],
   "source": [
    "# Import libraries\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import psycopg2\n",
    "import getpass\n",
    "import pdvega\n",
    "\n",
    "# for configuring connection \n",
    "from configobj import ConfigObj\n",
    "import os\n",
    "\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Database: eicu\n",
      "Username: alistairewj\n"
     ]
    }
   ],
   "source": [
    "# Create a database connection using settings from config file\n",
    "config='../db/config.ini'\n",
    "\n",
    "# connection info\n",
    "conn_info = dict()\n",
    "if os.path.isfile(config):\n",
    "    config = ConfigObj(config)\n",
    "    conn_info[\"sqluser\"] = config['username']\n",
    "    conn_info[\"sqlpass\"] = config['password']\n",
    "    conn_info[\"sqlhost\"] = config['host']\n",
    "    conn_info[\"sqlport\"] = config['port']\n",
    "    conn_info[\"dbname\"] = config['dbname']\n",
    "    conn_info[\"schema_name\"] = config['schema_name']\n",
    "else:\n",
    "    conn_info[\"sqluser\"] = 'postgres'\n",
    "    conn_info[\"sqlpass\"] = ''\n",
    "    conn_info[\"sqlhost\"] = 'localhost'\n",
    "    conn_info[\"sqlport\"] = 5432\n",
    "    conn_info[\"dbname\"] = 'eicu'\n",
    "    conn_info[\"schema_name\"] = 'public,eicu_crd'\n",
    "    \n",
    "# Connect to the eICU database\n",
    "print('Database: {}'.format(conn_info['dbname']))\n",
    "print('Username: {}'.format(conn_info[\"sqluser\"]))\n",
    "if conn_info[\"sqlpass\"] == '':\n",
    "    # try connecting without password, i.e. peer or OS authentication\n",
    "    try:\n",
    "        if (conn_info[\"sqlhost\"] == 'localhost') & (conn_info[\"sqlport\"]=='5432'):\n",
    "            con = psycopg2.connect(dbname=conn_info[\"dbname\"],\n",
    "                                   user=conn_info[\"sqluser\"])            \n",
    "        else:\n",
    "            con = psycopg2.connect(dbname=conn_info[\"dbname\"],\n",
    "                                   host=conn_info[\"sqlhost\"],\n",
    "                                   port=conn_info[\"sqlport\"],\n",
    "                                   user=conn_info[\"sqluser\"])\n",
    "    except:\n",
    "        conn_info[\"sqlpass\"] = getpass.getpass('Password: ')\n",
    "\n",
    "        con = psycopg2.connect(dbname=conn_info[\"dbname\"],\n",
    "                               host=conn_info[\"sqlhost\"],\n",
    "                               port=conn_info[\"sqlport\"],\n",
    "                               user=conn_info[\"sqluser\"],\n",
    "                               password=conn_info[\"sqlpass\"])\n",
    "query_schema = 'set search_path to ' + conn_info['schema_name'] + ';'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Examine a single patient"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "patientunitstayid = 2704494"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>patientunitstayid</th>\n",
       "      <th>apacheapsvarid</th>\n",
       "      <th>intubated</th>\n",
       "      <th>vent</th>\n",
       "      <th>dialysis</th>\n",
       "      <th>eyes</th>\n",
       "      <th>motor</th>\n",
       "      <th>verbal</th>\n",
       "      <th>meds</th>\n",
       "      <th>urine</th>\n",
       "      <th>...</th>\n",
       "      <th>ph</th>\n",
       "      <th>hematocrit</th>\n",
       "      <th>creatinine</th>\n",
       "      <th>albumin</th>\n",
       "      <th>pao2</th>\n",
       "      <th>pco2</th>\n",
       "      <th>bun</th>\n",
       "      <th>glucose</th>\n",
       "      <th>bilirubin</th>\n",
       "      <th>fio2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2704494</td>\n",
       "      <td>2305985</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>21.9</td>\n",
       "      <td>2.81</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   patientunitstayid  apacheapsvarid  intubated  vent  dialysis  eyes  motor  \\\n",
       "0            2704494         2305985          0     0         1     4      6   \n",
       "\n",
       "   verbal  meds  urine  ...    ph  hematocrit  creatinine  albumin  pao2  \\\n",
       "0       5     0   -1.0  ...  -1.0        21.9        2.81     -1.0  -1.0   \n",
       "\n",
       "   pco2   bun  glucose  bilirubin  fio2  \n",
       "0  -1.0  70.0    119.0       -1.0  -1.0  \n",
       "\n",
       "[1 rows x 26 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = query_schema + \"\"\"\n",
    "select *\n",
    "from apacheapsvar\n",
    "where patientunitstayid = {}\n",
    "\"\"\".format(patientunitstayid)\n",
    "\n",
    "df = pd.read_sql_query(query, con)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Missing data represented by -1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## apacheScore present but prediction is -1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Ventilation flags"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Unable to assess GCS (`meds` column)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Hospitals with data available"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>hospitalid</th>\n",
       "      <th>number_of_patients</th>\n",
       "      <th>number_of_patients_with_tbl</th>\n",
       "      <th>data completion</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>73</td>\n",
       "      <td>7059</td>\n",
       "      <td>5984</td>\n",
       "      <td>84.771214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>264</td>\n",
       "      <td>5237</td>\n",
       "      <td>4878</td>\n",
       "      <td>93.144930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>420</td>\n",
       "      <td>4679</td>\n",
       "      <td>4090</td>\n",
       "      <td>87.411840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>338</td>\n",
       "      <td>4277</td>\n",
       "      <td>4079</td>\n",
       "      <td>95.370587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>167</td>\n",
       "      <td>6092</td>\n",
       "      <td>3620</td>\n",
       "      <td>59.422193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>458</td>\n",
       "      <td>3701</td>\n",
       "      <td>3544</td>\n",
       "      <td>95.757903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>188</td>\n",
       "      <td>3601</td>\n",
       "      <td>3540</td>\n",
       "      <td>98.306026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>300</td>\n",
       "      <td>3617</td>\n",
       "      <td>3518</td>\n",
       "      <td>97.262925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>443</td>\n",
       "      <td>3656</td>\n",
       "      <td>3495</td>\n",
       "      <td>95.596280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>208</td>\n",
       "      <td>3650</td>\n",
       "      <td>3361</td>\n",
       "      <td>92.082192</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     hospitalid  number_of_patients  number_of_patients_with_tbl  \\\n",
       "43           73                7059                         5984   \n",
       "7           264                5237                         4878   \n",
       "165         420                4679                         4090   \n",
       "156         338                4277                         4079   \n",
       "170         167                6092                         3620   \n",
       "190         458                3701                         3544   \n",
       "145         188                3601                         3540   \n",
       "189         300                3617                         3518   \n",
       "166         443                3656                         3495   \n",
       "25          208                3650                         3361   \n",
       "\n",
       "     data completion  \n",
       "43         84.771214  \n",
       "7          93.144930  \n",
       "165        87.411840  \n",
       "156        95.370587  \n",
       "170        59.422193  \n",
       "190        95.757903  \n",
       "145        98.306026  \n",
       "189        97.262925  \n",
       "166        95.596280  \n",
       "25         92.082192  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = query_schema + \"\"\"\n",
    "select \n",
    "  pt.hospitalid\n",
    "  , count(pt.patientunitstayid) as number_of_patients\n",
    "  , count(a.patientunitstayid) as number_of_patients_with_tbl\n",
    "from patient pt\n",
    "left join apacheapsvar a\n",
    "  on pt.patientunitstayid = a.patientunitstayid\n",
    "group by pt.hospitalid\n",
    "\"\"\".format(patientunitstayid)\n",
    "\n",
    "df = pd.read_sql_query(query, con)\n",
    "df['data completion'] = df['number_of_patients_with_tbl'] / df['number_of_patients'] * 100.0\n",
    "df.sort_values('number_of_patients_with_tbl', ascending=False, inplace=True)\n",
    "df.head(n=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div class=\"vega-embed\" id=\"840f1fc3-1c79-4e9d-840d-3569e5ae53a7\"></div>\n",
       "\n",
       "<style>\n",
       ".vega-embed svg, .vega-embed canvas {\n",
       "  border: 1px dotted gray;\n",
       "}\n",
       "\n",
       ".vega-embed .vega-actions a {\n",
       "  margin-right: 6px;\n",
       "}\n",
       "</style>\n"
      ]
     },
     "metadata": {
      "jupyter-vega3": "#840f1fc3-1c79-4e9d-840d-3569e5ae53a7"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "var spec = {\"$schema\": \"https://vega.github.io/schema/vega-lite/v2.json\", \"width\": 450, \"mark\": \"bar\", \"height\": 300, \"data\": {\"values\": [{\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 84.77121405298202}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 93.14493030360894}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 87.41184013678136}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.37058685994856}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 59.42219304005253}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.75790326938666}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.30602610386003}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.26292507602986}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.59628008752735}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.08219178082192}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.16463957282706}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 68.51284468536413}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.63379802788167}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 61.96857670979667}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 61.9811320754717}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 91.22876333465032}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.40978846951472}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.00473933649289}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.60848831664282}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 62.626924336717984}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 91.04908565928778}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.21218378936499}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 57.330415754923415}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 63.27664005553627}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.46681057744199}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 90.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.08987485779295}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 94.70782800441015}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 83.15998018821199}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.22526817640048}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 75.22248243559719}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 89.16947250280583}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.68421052631578}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.13010204081633}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.93390614672836}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 53.152832205201285}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.83057577763071}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.03856749311295}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 90.0129701686122}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 65.4138915318744}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.32735426008968}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.46686976389947}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 62.032598274209015}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 60.9942638623327}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 69.87951807228916}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.37681159420289}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 94.02985074626866}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 62.88}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 66.68574699484832}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.78534923339012}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 89.64426877470356}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.82378854625551}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.2020202020202}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.72924187725631}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.52747252747253}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 82.63327948303716}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.8991935483871}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.57869012707722}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 93.45971563981043}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.89837398373984}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.79402677651905}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.82484725050917}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.67687434002113}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 86.41049671977507}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 79.37062937062937}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.19827586206897}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.88558352402745}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.48618784530387}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 51.36476426799007}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 80.2154750244858}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.0722891566265}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.29476248477467}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 78.64271457085829}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.10526315789474}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.65410497981158}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.4496644295302}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.34710743801654}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.66162310866575}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.71910112359551}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.42446043165467}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 50.50270688321732}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.08814589665653}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 93.19826338639653}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.12206572769952}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.72}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.66216216216216}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.65928449744463}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.29351535836177}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 67.33021077283372}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.82608695652175}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.7815699658703}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.58573853989813}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.11816578483244}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.45255474452554}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.81412639405205}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 81.30990415335462}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 72.54335260115607}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.8003992015968}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 71.16212338593975}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.79423868312757}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.35627530364373}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 79.9660441426146}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.78448275862068}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.90590809628009}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 58.09128630705395}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 47.88732394366197}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.3365617433414}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.5669099756691}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.54901960784314}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.08801955990221}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.2084432717678}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.83377308707124}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.1825613079019}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.44444444444444}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.72067039106145}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.85714285714286}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.76139410187668}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.45762711864407}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.71098265895954}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 68.34677419354838}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.27507163323781}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 94.10112359550563}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.69604863221885}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 69.21397379912663}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.34146341463415}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.42271293375394}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 54.37062937062937}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.67320261437908}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.05825242718447}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.37662337662337}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 93.37748344370861}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.55244755244755}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.4375}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 78.50467289719626}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 47.04761904761905}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.3265306122449}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 72.61538461538461}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 47.16599190283401}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 93.52226720647774}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 33.82352941176471}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.99570815450643}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 88.23529411764706}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.68421052631578}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.66666666666667}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.53488372093024}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.52380952380952}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.96969696969697}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.40932642487047}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 77.25321888412017}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.29545454545455}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.375}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 68.63636363636364}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.01324503311258}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 97.91666666666666}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 99.26470588235294}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 74.01129943502825}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.38709677419355}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 32.020997375328086}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.36641221374046}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 88.52459016393442}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.4954954954955}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 61.06870229007634}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.57142857142858}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 95.45454545454545}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.36065573770492}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 74.28571428571429}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 98.11320754716981}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.5925925925926}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 72.72727272727273}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.7741935483871}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 96.29629629629629}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 51.515151515151516}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 80.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 60.86956521739131}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 93.33333333333333}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 92.3076923076923}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 14.814814814814813}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 100.0}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 21.428571428571427}, {\"Number of hospitals\": \"data completion\", \"Percent of patients with data\": 66.66666666666666}]}, \"encoding\": {\"y\": {\"aggregate\": \"count\", \"stack\": null, \"type\": \"quantitative\"}, \"x\": {\"bin\": {\"maxbins\": 10}, \"field\": \"Percent of patients with data\", \"type\": \"quantitative\"}, \"color\": {\"field\": \"Number of hospitals\", \"type\": \"nominal\"}}, \"selection\": {\"grid\": {\"bind\": \"scales\", \"type\": \"interval\"}}};\n",
       "var selector = \"#840f1fc3-1c79-4e9d-840d-3569e5ae53a7\";\n",
       "var type = \"vega-lite\";\n",
       "\n",
       "var output_area = this;\n",
       "require(['nbextensions/jupyter-vega3/index'], function(vega) {\n",
       "  vega.render(selector, spec, type, output_area);\n",
       "}, function (err) {\n",
       "  if (err.requireType !== 'scripterror') {\n",
       "    throw(err);\n",
       "  }\n",
       "});\n"
      ]
     },
     "metadata": {
      "jupyter-vega3": "#840f1fc3-1c79-4e9d-840d-3569e5ae53a7"
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAngAAAFfCAYAAADd1rEpAAAgAElEQVR4Xu2dCbx1VV2/nzTnnEkjLbWrpaIZ6iuIOFAQDq9jvamlOSJDKk7Jm6kgat2rWIID2iukqWn5d0ihHMAhLU1MxQEJ1AgHnHKAHFD0/j/f13X0cD333nPumdba59mfDx/g3r3X/q3nt+49z/2ttff6OTwkIAEJSEACEpCABDpF4Oc61Rs7IwEJSEACEpCABCSAgucgkIAEJCABCUhAAh0joOB1LKF2RwISkIAEJCABCSh4jgEJSEACEpCABCTQMQIKXscSanckIAEJSEACEpCAgucYkIAEJCABCUhAAh0jME/Bux/wCmAbcHbhejXgH4EbAZ8EHgB8HzgOOBC4BDgcOKNjebA7EpCABCQgAQlIYGIE5iV4twcOAW4MPKpP8J4DXAD8NfAM4K3A5YCjgO3AXsBJwD4TI2BDEpCABCQgAQlIoGME5iV4VwG+DZwGPLpP8D4B7Adc2Mf5GOB84OTytbOAfdec07G02B0JSEACEpCABCSwdQLzErxexGsF7zzgpWU6NtO2jweOB04BTi0X5ZojgHO23m2vlIAEJCABCUhAAt0lUJvgXQTcHXgv8ALgU8At1wje6cBhwLkrKytHr66upsL3k2OPPfb43gEHHHDF7qbMnklAAhKQgAQ2JHDe0tJS1rJ7LDCB2gTvXOCmwA+BewJ3Bb5c1uXtKnlKZS8PZkQGf+ZYXl5e3blz57z7tcBDyq5LQAISkMA8CXzmM59ZXVpamsTnYB5ufAfwEeA2wCpw2/KgYz6HPzSBfmZW7hfK0qsJNLdhE3lw88XAt8rDnL2T9y+FpbuVtf/TjCMPi+bB0Z3AHsAfAidscsP+a4aObRIDYOibDThx7RTtC4G3A28GloHPlYF1LHAQsHcBkWQMPBS8cdLhtRKQgAQk0DqBKQhexO5BwN83LnhZ7vVrwM3X5HiWgneD8gzBN4BHFtHLA6cbHU0JXp6cfSxwQ+CL5ZUo9y02+6ry788CDwG+W2TvYOBi4FDgTAWv9V9Bxi8BCUhAAtMgMAXByxr4m5UZtlv1VfCuD7yxFF8+Cjy/SEsqclk+9UTgecCfliVX+VoqaFcowpjqYAo9VwX+p7wt4/3ADuDrpbCTt2r8KvBh4GFA1upnlu9vgHsBTwBe28fxl4ATgbsA3wFeV97EsQIcWc5LBe8afdf0BO9pwCNKPE8CXl7e5PGX5bVteUD0X8tzAF8ozwskvpuUgtSfl1e95Zy8AeSrwB1L7L0+9WQtD5W+ssQQt8lr4l4E5BVylwFeDTymVE37BS/PJqTPqf59rMSbtn7mmHcFb+Jj2wrexJHaoAQkIAEJNERgCoJ35zJ1mVeWRcDyLtpM0W4keE8FnlmkLNWqNwHvAn4f+EARot8pgncn4B5FZjKL92zgr4D/LoKYGb28IzfSlFemRXgiWGkrS7u+2ZeeVOnySrUs8Uq1LnL65CKf/wxcu7ytI1LVO3qCl3s/vUho+nZdIKIXOcz0bSQ0zwFEZhNHpDNv9sj7ef+giG7eDBJpjdj9JhDPioBFEiOQPVl7SnkXcN4ckoribxRxjLhGPnOfTJHn371r0kb6+idFDiOUiSlCq+A19DNqqBKQgAQkIIGRCUxB8FKhynTiw4vIRNSGFbyrFzH7Wqmk5X23qapFwiI2kaFIV5Zg5Yiw5Z9UA99WXqkWwblsWXv/y0V48saNiE7/kXMy6xfh6VXrsm4/EpRZwLxbN5WvrCPsP3qCF2F8fZG8vIs3lcZ/KdekcpnjJWV28crlvbx/VKp67wb+tsxKpk/XLOsWc81/AZ8pD5H2V+NSIcy9M0WbuNKnSOEPSsX0oUUC+6UwbYVXchA+qQKmzwreyD8pXiABCUhAAhJoiMCUBC+ClqVTqShFhCJ41yuVuTyAkWpWBCXCkynaXgXvSkDebJEqXqYXI26ZUv2tMuUbGboWcOuC+NPl3bgRwfcA9wH+aQ3+9dakRfAyLRsJ6wleXqkWueo9QLGR4PXOyQMQqZYl9lQAc01P8FJhy3rETNdmKjXXpNKWONPPLD1LFbFfWnP/vBWkV33sPWTRL3iZyk4l8FdK5TC7eWVKOuf09zdTuZnGPaDcM2J5bwWvoR9QQ5WABCQgAQlshcCUBC/ilanOiE/EJoKXf/8H8GelkvRvRYZGFbxMAWe6NlOwWZeXadK8Ki2Vt0ybRtZy36+UGDZ66CBylderpb2sG4wcZs1/HuLcrII3SPAy5Zop2lQA88xAhPTfgfuXDRjy//8APBh4GZA1gFk/1+vT5fv6lCnr/thzftbm3aKsWUybS6XSmZiz1i5P2PauyfkRwfCJuGY9Y3b2WvvQyO5h4xq8rfz0eI0EJCABCUigUgJTFLxUqDJ9mvVpvdek/B3we8DHSxUvD0emujVsBS9VurhIKnx5W0YqUg8srzLJOroITapieVVLpogjNhsJXqZw87BCKlx5nVqmMLP2LQ9mbEXwflTkMjFlyrb39o88QJFp6/Qz94z8PbfcO+dkavpLRTT7+9Qfex4SyYOl3y/Tt6lsZmo3D6X8bnmIJJXOrOFL1S9r7vJQR16tEolOVTBV0bT/M4eCV+kPqGFJQAISkIAEtkJggoK3ldt7zY8lcFbv9luXt4LnUJSABCQgAQl0iICCN/dkKnjTSIGvSZkGVduUgAQkIIFWCCh4rWRqunFawZsuX1uXgAQkIAEJzJSAgjdT3NXeTMGrNjUGJgEJSEACEhidgII3OrMuXqHgdTGr9kkCEpCABBaWgIK3sKm/VMcVPMeBBCQgAQlIoEMEFLwOJXOMrih4Y8DzUglIQAISkEBtBCYleNt3vnZ1mL6dsvyAUV3ivPJuu/Waz84Ma3evGCaUaZzTe0FyXqA86Mies9l1Ike2Ocv796o4Rk1KFUFvFIRP0VafIgOUgAQkUC2BYaWm2g4Axx+yjaWlpbE/34dlMWHBy1Zd2bUi24HVcGwmeCeVeLPTR1XH2AOgqt4ACl5tGTEeCUhAAu0QGFZqau5RhYJ3ZeB1hVn2rM22XtmdIpW6o8pODucD2QUjuzncoezckL1ts9PDNcqLg58EvHcN+8cADwWy40S28PoX4LCy20O+lq3Pnl22/IrzZH/ZXy87XPS2+co+sjmyLdoZZR/Z7FRxaN8WZ9mTNtun3aTsaJG9crNTxhvKLh5HlFhvC+wXHSn74maHjuzAkW3Q/gC4sGxHlmpfthqb2qHgTQ2tDUtAAhKQQGsEFLyfZmxYFkNU8P4YuD1weNm66+VAKnURnwjZBcCbgWcB2bs1gpYK3o3KdX8P3Lp8/+59YypbhOX62wB7FqmKBOZFw9niK9uTfaAIZe79deDYInvZHizn/gVwVtnG7PPA9YD/LW1EPh9Wvpd9cvcHnghctbSbPWQjkIn3m+W8CN6ZwP2Az5St1s4GIoxpLxyuVvbwzV65UzsUvKmhtWEJSEACEmiNwLBSU3O/KqzgpZoVyYnYReAiPhG87Lf6BOBi4FZFlP6vT/Cy9+3x5dzLlErevn3sI3s7ioT1vpw2I4eRyhypuqXql6pa/p3K2THA54BMr0byvgv8A/BO4DfLddnzNdW8XJc9bO8MbAe+XL4focz3cl2/4KX6mP1yb1DOyz69v1OqgwcXyc23NluHOPYQU/DGRmgDEpCABCTQFQIK3lQqeCulSvYKINJ2LvCrRXIyTfqlMr2Z6dh+wTuynJeq2Y3LOf2CF2H6wzK12wv8oPL/vTV8LwLeVapv7wbeVAQvghXhjOB9r0wN/ytw89JQxDLVvwhbBC+Vt1yza81YT7VwreD1+pdTI6CRw5x3IPDocr2CN+ovDdfgjUrM8yUgAQlIoEdAwZuK4GUqNtOof1KqYCeWtWxZd3dd4DqlWhb5+Rrw+CJGedjiC2Ud3J+Vr2Wqtnfk2khbpmOvArymVO7ytVQELylToQ8sYrWZ4OVeEc+vAO8va/AOKYKXCmL++57A1YGnlCnXrNtLvKnsRQQzRfuRst4uovd84GNleljBG+dXjYI3Dj2vlYAEJLDYBBS8qQjeL5SHEVK9+3cg05Z5WCHVtchZqlnvA/Kgwl3LOZG1V5eqXSp8LyuVt0yd5r97R66JQGZG8qllTd4ji+jlNS9Z2/e8IlqbCV6maD9YYsurT9J27ynaPGRxArA3cFkgD1m8EXhaWeOXB0fSnwheqpL5fqaeE3viyXSygjfOrxcFbxx6XisBCUhgsQkoeFMRvBYG1R59FbgW4t00RtfgbYrIEyQgAQlIYFEIKHgKXlfGuoLXlUzaDwlIQAISGJuAgjc2QhuohICCV0kiDEMCEpCABOZPQMGbfw6MYDIEFLzJcLQVCUhAAhLoAAEFrwNJtAu7CSh4DgQJSEACEpBAIaDgORS6QkDB60om7YcEJCABCYxNQMEbG6ENVEJAwaskEYYhAQlIQALzJ6DgzT8HRjAZAgreZDjaigQkIAEJdICAgteBJNqF3QTmKXj3A7Iv3bayCXF/SrL/XN4KnTdC5ziuvAE6244cXrY0GZhCX3TsyJaABCQgga0SUPC2Ss7raiMwL8HLpr3Z0y2bBz9qjeDtWbYmyV5vEbw7lf3etgN7ASeVbUAUvNpGk/FIQAISaJyAgtd4Ag3/JwTmJXjZFPjbwGllA+Cz+3KSveey99sLiuAdA2RD4pPLOWcB+wIXDsqjFTxHtwQkIAEJbJWAgrdVcl5XG4F5CV6Pw1rBOwi4B7CzbDycCt6JwClANvrNkWuyAfA5Cl5tw8l4JCABCbRNQMFrO39G/1MCNQneFYC3AfcEfrCB4J0OHAacq+A5lCUgAQlIYJIEFLxJ0rSteRKoSfDuUNbXfbM8/JH1dpmu/QJwAbCrgMp0bh7MuGhlZeXo1dXVTOFe6tixY8c8mXpvCUhAAhJolMCRu85oNPKfhn38IdtYWlqa9+d78xxb78C8B8CgNXhhesW+Ct5+wLFApm/3Bk4A9l8PvGvwWh+Sxi8BCUhgfgSs4M2PvXeeLIF5CV6enH0scEPgi8Angfv2da1f8PLlZeBg4GLgUOBMBW+yA8HWJCABCUgAFDxHQVcIzEvwpsbPCt7U0NqwBCQggc4TUPA6n+KF6aCCtzCptqMSkIAEJLAZAQVvM0J+vxUCCl4rmTJOCUhAAhKYOgEFb+qIvcGMCCh4MwLtbSQgAQlIoH4CCl79OTLC4QgoeMNx8iwJSEACElgAAgreAiR5Qbqo4C1Iou2mBCQgAQlsTkDB25yRZ7RBQMFrI09GKQEJSEACMyCg4M0AsreYCQEFbyaYvYkEJCABCbRAQMFrIUvGOAwBBW8YSp4jAQlIQAILQUDBW4g0L0QnFbyFSLOdlIAEJCCBYQgoeMNQ8pwWCCh4LWTJGCUgAQlIYCYEFLyZYPYmMyCg4M0AsreQgAQkIIE2CCh4beTJKDcnoOBtzsgzJCABCUhgQQgoeAuS6AXopoK3AEm2ixKQgAQkMBwBBW84Tp5VPwEFr/4cGaEEJCABCcyIgII3I9DeZuoEFLypI/YGEpCABCTQCgEFr5VMGedmBBS8zQj5fQlIQAISWBgCCt7CpLrzHVXwOp9iOygBCUhAAsMSUPCGJeV5tRNQ8GrPkPFJQAISkMDMCCh4M0PtjaZMQMGbMmCbl4AEJCCBdggoeO3kykg3JqDgOUIkIAEJSEAChYCC51DoCgEFryuZtB8SkIAEJDA2AQVvbIQ2UAkBBa+SRBiGBCQgAQnMn4CCN/8cGMFkCCh4k+FoKxKQgAQk0AECCl4HkmgXdhNQ8BwIEpCABCQggUJAwXModIWAgteVTNoPCUhAAhIYm4CCNzZCG6iEgIJXSSIMQwISkIAE5k9AwZt/DoxgMgQUvMlwtBUJSEACEugAAQWvA0m0C7sJKHgOBAlIQAISkEAhoOA5FLpCQMHrSibthwQkIAEJjE1AwRsboQ1UQmCegnc/4BXANuDswuO2wEuAywNnAg8FfggcBxwIXAIcDpyxHr/l5eXVnTt3zrNflaTWMCQgAQlIYFQCCt6oxDy/VgLzEqHbA4cANwYe1Sd4EbeHAx8HXg28HvgacBSwHdgLOAnYR8GrdUgZlwQkIIF2CSh47ebOyC9NYF6CdxXg28BpwKP7BG9P4IIS4gpwLnB94Hzg5PL1s4B9gQsHJdMKnkNcAhKQgAS2SkDB2yo5r6uNwLwEr8dhreD1vn5t4D3AAcCxwCnAqeWbueYI4BwFr7bhZDwSkIAE2iag4LWdP6P/KYEaBS9yF6F7OvAO4MQ1gnc6cFiqeysrK0evrq4eszahO3bsMMcSkIAEJCCBkQkcuWvdJd4jtzWvC44/ZBtLS0vz/nyfV/e9byEw7wGwtoJ35SJ1zwTeWmKM6GXadlf5/zyQkQczLrKC5ziWgAQkIIFJErCCN0matjVPArUJ3vHAh4BX9kHZr0zTHgTsDZwA7L8eNNfgzXM4eW8JSEACbRNQ8NrOn9H/lMC8BC9Pzj4WuCHwReCTwH2Bi8uDFb0II3p52GIZOLh8/9DyCpWBeVTwHN4SkIAEJLBVAgreVsl5XW0E5iV4U+Og4E0NrQ1LQAIS6DwBBa/zKV6YDip4C5NqOyoBCUhAApsRUPA2I+T3WyGg4LWSKeOUgAQkIIGpE1Dwpo7YG8yIgII3I9DeRgISkIAE6ieg4NWfIyMcjoCCNxwnz5KABCQggQUgoOAtQJIXpIsK3oIk2m5KQAISkMDmBBS8zRl5RhsEFLw28mSUEpCABCQwAwIK3gwge4uZEFDwZoLZm0hAAhKQQAsEFLwWsmSMwxBQ8Iah5DkSkIAEJLAQBBS8hUjzQnRSwVuINNtJCUhAAhIYhoCCNwwlz2mBgILXQpaMUQISkIAEZkJAwZsJZm8yAwIK3gwgewsJSEACEmiDgILXRp6McnMCCt7mjDxDAhKQgAQWhICCtyCJXoBuKngLkGS7KAEJSEACwxFQ8Ibj5Fn1E1Dw6s+REUpAAhKQwIwIKHgzAu1tpk5AwZs6Ym8gAQlIQAKtEFDwWsmUcW5GQMHbjJDfl4AEJCCBhSGg4C1MqjvfUQWv8ym2gxKQgAQkMCwBBW9YUp5XOwEFr/YMGZ8EJCABCcyMgII3M9TeaMoEFLwpA7Z5CUhAAhJoh4CC106ujHRjAuMI3hWBqwFfqQny8vLy6s6dO8fpV03dMRYJSEACEpghAQVvhrC91VQJjCpCDwTuACwD/wlcB3g08KKpRjlC4wreCLA8VQISkIAELkVAwXNAdIXAqIJ3HnAscH3gYcCzgacCN6wFiIJXSyaMQwISkEB7BBS89nJmxIMJjCp4FwPXBt4CfAR4CvAt4Aq1AFbwasmEcUhAAhJoj4CC117OjHgygvcJ4KPA/YH7Ftk7BrhRLYAVvFoyYRwSkIAE2iOg4LWXMyOejOAdBDynrL97FPBy4J3l31UwVvCqSINBSEACEmiSgILXZNoMegCBUado1zZxWeCHNZFV8GrKhrFIQAISaIuAgtdWvox2fQLDCt4pG0C8HHBwLZAVvFoyYRwSkIAE2iOg4LWXMyMeb4o26+5ypGJ3M+C/yn//OnAGsE8tgBW8WjJhHBKQgATaI6DgtZczIx5P8HpXvx54PvDe8oW7AQ8C/mgLgO8HvALYBpxdrr8l8DLg8sAHgMPL148DDgQuKV+LVA48FLwtZMJLJCABCUhgNwEFz4HQFQLDTtH2+vsd4M6lapev3RF4M3DNEYHcHjgEuDGQhzV6gpcHNnYCHwReB5wMfBs4Kj93wF7ASRtVDBW8ETPh6RKQgAQk8BMCCp6DoSsERhW8dwB3AT4F5NqbA/8G3GlEIFcp4nZa2Qkjgpe1fPn3Umkrr2K5HXARcH6RvXzrLGBf4MJB91TwRsyEp0tAAhKQgILnGOgcgVEFbw/gyWVaNTA+BDx3jP1o+wXvukAe5siUbY79gSPKi5Tz9VPL13NNvn6Ogte58WiHJCABCcyVgBW8ueL35hMkMKrgvRR4OvDlCcWwkeBl+vewUqnrF7zTy9fPVfAmlAWbkYAEJCCB3QQUPAdCVwiMKnh58GEFeOOEAPQL3s8DkbberhgPBG5TBO8CYFe5Z6ZxU+W7aGVl5ejV1dXspHGpY8eOHRMKz2YkIAEJSGCRCBy5a91n+JrBcPwh21haWhr1872Z/hnocARGHQBvAw4oIpa1cb0ja+K2cvQLXq5/O/DM8pTuPwEvAPJgx7FAdtHYGzihTN8OvJ9r8LaSBq+RgAQkIIEQsILnOOgKgVEF793lVSVr+59XmIxy5MnZxwI3BL4IfLLsbZuHNvKU7BWA3OsJpdHl8jLli4FDgTPXu5mCN0oaPFcCEpCABPoJKHiOh64QGFXwev3uXbdaGwgFr7aMGI8EJCCBdggoeO3kykg3JjCq4F0PyIMWvwNE7v65vHj4q7WAVvBqyYRxSEACEmiPgILXXs6MeDCBUQUvLzXOOriIXa7Ny4f/FXhALYAVvFoyYRwSkIAE2iOg4LWXMyOejOB9o+wi0XsH3S2A9wDXrgWwgldLJoxDAhKQQHsEFLz2cmbEkxG8PBDxECA7WuT4XeBvgUzdVnEoeFWkwSAkIAEJNElAwWsybQY9gMCoU7R/BRwJfBy4TNkbNl/701roKni1ZMI4JCABCbRHQMFrL2dGPJkK3uWBxwF3BX4E/Et5L90PagGs4NWSCeOQgAQk0B4BBa+9nBnxZAQvrVyn7D2bnSf2BD5XE1wFr6ZsGIsEJCCBtggoeG3ly2jXJzDqFO39y5ZhVwOuUUQvT9C+oRbICl4tmTAOCUhAAu0RUPDay5kRT6aC9xkgW4hlh4nLAtlh4l7Ab9QCWMGrJRPGIQEJSKA9Agpeezkz4skIXvafvSVwXmkuW419DEhFr4pDwasiDQYhAQlIoEkCCl6TaTPoAQRGnaJ9a9k/Ng9X5Np7AKnq5aGLKg4Fr4o0GIQEJCCBJgkoeE2mzaAnIHg3AP4GuEsRvOxi8Qjgf2qhq+DVkgnjkIAEJNAeAQWvvZwZ8WACo1bw0soVgZsAZ5V1eN+vCa6CV1M2jEUCEpBAWwQUvLbyZbTrExhV8LJzxauBqxbRy1TtC4FTa4Gs4NWSCeOQgAQk0B4BBa+9nBnxZCp4qdqdBDwduDpwVNm67Oa1AFbwasmEcUhAAhJoj4CC117OjHgygpenaK8JfK28By9P0X4C+IVaACt4tWTCOCQgAQm0R0DBay9nRjwZwXsncDFwAPASYDtwPvDbtQBW8GrJhHFIQAISaI+Agtdezox4MoJ3Y+Bk4I5A9p/9N+AQ4NO1AFbwasmEcUhAAhJoj4CC117OjHgygtdr5QrAJcAPgSsB360FsIJXSyaMQwISkEB7BBS89nJmxOMJ3i8CK8Ctypq7JwNfBu5QKnpuVeYIk4AEJCCB5gkoeM2n0A4UAsO+JuV1wH2AjwA3Az5c/vsxZXpWwXNISUACEpBA8wQUvOZTaAdGFLyvA08FXgzcFjijrMF7DvDM8uBFFVCdoq0iDQYhAQlIoEkCCl6TaTPoAQSGreCtlidn311ecJw1d/cC3lIbVQWvtowYjwQkIIF2CCh47eTKSDcmMI7g3R74QG2AFbzaMmI8EpCABNohoOC1kysjnZzgnQd8G4gUZueKz/Y9PXuLWkAreLVkwjgkIAEJtEdAwWsvZ0Y8mMCwFbz3bQJw/1oAK3i1ZMI4JCABCbRHQMFrL2dGPJ7gNcNPwWsmVQYqAQlIoDoCCl51KTGgLRIYtoK3xeZnf5mCN3vm3lECEpBAVwgoeF3JpP1Q8BwDEpCABCQggUJAwXModIXAsIKX/WZ3AY8DXlC2KJsGg4OApwHfB74JPLg8yHEccGDZHu3w8h6+gfe3gjeNtNimBCQggcUgoOAtRp4XoZfDCt53gIcC/wDcr7zkuJ/PKROC9QkgkncB8Hzgo+Vp3aOA7cBewEnAPuvdT8GbUCZsRgISkMACElDwFjDpHe3ysIL3XmCjJ2WHbWczjO8B/qTsd3sy8Iayc8b5Zc/bXH8WsC9w4aDGFLzNEPt9CUhAAhJYj4CC59joCoFhxexKpXqWLcruXKZQ+xlM6oXH2QbtVOCrwOeAuwEnAqkQ5us5TgOOAM5R8LoyDO2HBCQggToIKHh15MEoxicwrOD17nSNIne3ArJ92Zl9LzseP5of74zxCOCTwAuBD5Xp2H7BOx04DDh3ZWXl6NXV1WPW3njHjh2TiMU2JCABCUhgwQgcuSt1jLaP4w/ZxtLS0qif72132uh/hsCoA2A/4I3AdUpLny970n5kAmyvAJwN3Ki0dW/gYOBLZU1eHvLIkXO2ARcNuqdTtBPIhE1IQAISWFACVvAWNPEd7PaogvdB4GvAK8uWZQ8HImZ3nBCbTwN3Ar4IHAt8A/iP8t95+GJv4ISN1gMqeBPKhM1IQAISWEACCt4CJr2jXR5V8LIX7Y1LRS1Irg98CrjqhPhE4o4Gvgf8b5mu/T9guVTzLgYOLVPDA2+p4E0oEzYjAQlIYAEJKHgLmPSOdnlUwcuDDX9X1sddBng08CDg12vho+DVkgnjkIAEJNAeAQWvvZwZ8WACowpepmTzHrrekQctHga8ohbACl4tmTAOCUhAAu0RUPDay5kRT0bw0kpeMpyHH34EvLU86VoNXwWvmlQYiAQkIIHmCCh4zaXMgNchMGoFr3qQCl71KTJACUhAAtUSUPCqTY2BjUhAwRsRmKdLQAISkEB3CSh43c3tovVMwVu0jNtfCUhAAhJYl4CC5+DoCoFRBS/7wN4D+O9aAThFW2tmjEsCEpBA/QQUvPpzZITDERhV8I4vO0j0/t27S95bV8Wh4FWRBoOQgAQk0CQBBa/JtBn0AAKjCl62B7tK2cWiv7lR25laMhS8qaG1YQlIQAKdJ6DgdT7FC9PBUcXsGOCSAXSeVQsxBa+WTBiHBCQggfYIKHjt5cyIBxMYVfDSym2B2wEvBm4OZF1eNVaONTgAACAASURBVIeCV00qDEQCEpBAcwQUvOZSZsDrEBhV8J4MrJS9Yq8EvB94M/CXtRBW8GrJhHFIQAISaI+Agtdezox4MhW8zwP3Bk4HrgHctWxddr1aACt4tWTCOCQgAQm0R0DBay9nRjwZwftf4CbAZ4vg3QF4C3CtWgAreLVkwjgkIAEJtEdAwWsvZ0Y8GcF7OXA34NrAJ4BbAK8EHlYLYAWvlkwYhwQkIIH2CCh47eXMiCcjeFl392fAgWUd3nuA44Bv1wJYwaslE8YhAQlIoD0CCl57OTPiyQheWrkacFPgR8CnapK7BKfgOdQlIAEJSGCrBBS8rZLzutoIjPoU7SOAE4Arl45cCBwKvLaWjil4tWTCOCQgAQm0R0DBay9nRjyZCt5XgP8oQhc5fACwN+BTtI4wCUhAAhJonoCC13wK7UAhMGoFL69JuT3wuXL9nsCHgfy7isMKXhVpMAgJSEACTRJQ8JpMm0EPIDCs4OV9dzl+u7wmJU/TrgIPAc4pD15UAVjBqyINBiEBCUigSQIKXpNpM+gxBC8yt9ExrChOPQkK3tQRewMJSEACnSWg4HU2tQvXsWHFbP8NyFwOeFct5BS8WjJhHBKQgATaI6DgtZczIx5MYFjB6119WSC7V/wScJm+Jn2K1hEmAQlIQALNE1Dwmk+hHSgERhW8NwP3HEBv1HamlgAreFNDa8MSkIAEOk9Awet8ihemg6OK2XeBRwMfAH7YR+nsWogpeLVkwjgkIAEJtEdAwWsvZ0Y8mSnaVwF/B7y9VqAKXq2ZMS4JSEAC9RNQ8OrPkREOR2DUCl6qd88Hvl/+6d3lGsPdbvpnKXjTZ+wdJCABCXSVgILX1cwuXr9GFbz/Az4OfGjNFO3jakGn4NWSCeOQgAQk0B4BBa+9nBnxZKZoP1meov3mlIBeDfhH4EZA7pWt0FItPA44ELgEOBw4Y737K3hTyozNSkACElgAAgreAiR5Qbo4agXvRUDeiXf6minanRPi9RzgAuCvgWcAbwXynr2jgO3AXsBJwD4K3oSI24wEJCABCfyEgILnYOgKgVEF70dA/ll7/PyEgHwC2A+4sK+9Y4DzgZPL184C9l1zzk9Ot4I3oUzYjAQkIIEFJKDgLWDSO9rlUQUv52+2bdk4qM4DXlqmY/PqlccDxwOnAKeWhk8Djih74P7MvRS8cfB7rQQkIIHFJqDgLXb+u9T7UQXvSQM6nzaeOyEoFwF3B94LvAD4FHDLNYKX6eHDgHMH3VPBm1AmbEYCEpDAAhJQ8BYw6R3t8qiCN6h6lxceT2qKNtJ20/KEbnbMuCvw5bIub1fJQSp724CLVlZWjl5dXc0U7qWOHTt2dDRddksCEpCABKZJ4Mhd6z7DN83bTrTt4w/ZxtLS0qif7xONwcbmT2DUAdD/vrsrAQ8F8uqUVNsmcbywvEQ5W6ItA58DPgIcCxwE7A2cUB70GHg/K3iTSINtSEACElhMAlbwFjPvXez1qIK3lsGeQB56uOaE4OwBZLeM/PuzwEOAbI8W2TsYuBg4FDhzvfspeBPKhM1IQAISWEACCt4CJr2jXR5V8N7Ux+GywG2KdOW9dVUcCl4VaTAICUhAAk0SUPCaTJtBDyAwquB9tK+NrMf7IvAs4P210FXwasmEcUhAAhJoj4CC117OjHgwgVEFr3qOCl71KTJACUhAAtUSUPCqTY2BjUhgWMHLe+g2OrLLRBWHgldFGgxCAhKQQJMEFLwm02bQAwhsVfAyPZunaA8ALgMM287Uk6DgTR2xN5CABCTQWQIKXmdTu3Ad24qYReweC2T/2e+XNXiTek3K2AlQ8MZGaAMSkIAEFpaAgrewqe9cx0cRvDw1m/fePQO4GvC88k/eg1fNoeBVkwoDkYAEJNAcAQWvuZQZ8DoEhhW8+wB/ASwBLylVu6/WSFXBqzErxiQBCUigDQIKXht5MsrNCQwreFlzl39OK1uHrb3uQZvfajZnKHiz4exdJCABCXSRgILXxawuZp+GFbz3bYJn/1rwKXi1ZMI4JCABCbRHQMFrL2dGPJjAsILXDD8Fr5lUGagEJCCB6ggoeNWlxIC2SEDB2yI4L5OABCQgge4RUPC6l9NF7ZGCt6iZt98SkIAEJPAzBBQ8B0VXCCh4Xcmk/ZCABCQggbEJKHhjI7SBSggoeJUkwjAkIAEJSGD+BBS8+efACCZDQMGbDEdbkYAEJCCBDhBQ8DqQRLuwm4CC50CQgAQkIAEJFAIKnkOhKwQUvK5k0n5IQAISkMDYBBS8sRHaQCUEFLxKEmEYEpCABCQwfwIK3vxzYASTIaDgTYajrUhAAhKQQAcIKHgdSKJd2E1AwXMgSEACEpCABAoBBc+h0BUCCl5XMmk/JCABCUhgbAIK3tgIbaASAgpeJYkwDAlIQAISmD8BBW/+OTCCyRBQ8CbD0VYkIAEJSKADBBS8DiTRLuwmoOA5ECQgAQlIQAKFgILnUOgKAQWvK5m0HxKQgAQkMDYBBW9shDZQCQEFr5JEGIYEJCABCcyfgII3/xwYwWQIKHiT4WgrEpCABCTQAQIKXgeSaBd2E1DwHAgSkIAEJCCBQkDBcyh0hYCC15VM2g8JSEACEhibgII3NkIbqIRArYJ3JPBg4LaF03HAgcAlwOHAGevxW15eXt25c2et/aok7YYhAQlIQAKDCCh4jouuEKhRhPYEXgVcvQjenYCjgO3AXsBJwD4KXleGoP2QgAQkUA8BBa+eXBjJeARqFLxXAy8EXlAE7xjgfODk0tWzgH2BCwd13QreeAPCqyUgAQksMgEFb5Gz362+1yZ4BwH3AHYC7yuCdyJwCnBqQX8acARwjoLXrcFobyQgAQnMm4CCN+8MeP9JEahJ8K4AvA24J/CDDQTvdOAw4NyVlZWjV1dXU+G71LFjx45J8bEdCUhAAhJYIAJH7lp3iXczFI4/ZBtLS0s1fb43w65LgdY0AO5Q1td9s7y+JevtMl37BeACYFcBfzawDbjICl6XhqJ9kYAEJDB/Albw5p8DI5gMgZoEr79HV+yr4O0HHAtk+nZv4ARg//W67xq8yQwMW5GABCSwiAQUvEXMejf73ILghfwycDBwMXAocKaC180Baa8kIAEJzJOAgjdP+t57kgRqFbwt99EK3pbReaEEJCCBhSeg4C38EOgMAAWvM6m0IxKQgAQkMC4BBW9cgl5fCwEFr5ZMGIcEJCABCcydgII39xQYwIQIKHgTAmkzEpCABCTQPgEFr/0c2oMfE1DwHAkSkIAEJCCBQkDBcyh0hYCC15VM2g8JSEACEhibgII3NkIbqISAgldJIgxDAhKQgATmT0DBm38OjGAyBBS8yXC0FQlIQAIS6AABBa8DSbQLuwkoeA4ECUhAAhKQQCGg4DkUukJAwetKJu2HBCQgAQmMTUDBGxuhDVRCQMGrJBGGIQEJSEAC8yeg4M0/B0YwGQIK3mQ42ooEJCABCXSAgILXgSTahd0EFDwHggQkIAEJSKAQUPAcCl0hoOB1JZP2QwISkIAExiag4I2N0AYqIaDgVZIIw5CABCQggfkTUPDmnwMjmAwBBW8yHG1FAhKQgAQ6QEDB60AS7cJuAgqeA0ECEpCABCRQCCh4DoWuEFDwupJJ+yEBCUhAAmMTUPDGRmgDlRBQ8CpJhGFIQAISkMD8CSh488+BEUyGgII3GY62IgEJSEACHSCg4HUgiXZhNwEFz4EgAQlIQAISKAQUPIdCVwgoeF3JpP2QgAQkIIGxCSh4YyO0gUoIKHiVJMIwJCABCUhg/gQUvPnnwAgmQ0DBmwxHW5GABCQggQ4QUPA6kES7sJuAgudAkIAEJCABCRQCCp5DoSsEFLyuZNJ+SEACEpDA2AQUvLER2kAlBBS8ShJhGBKQgAQkMH8CCt78c2AEkyGg4E2Go61IQAISkEAHCCh4HUiiXdhNQMFzIEhAAhKQgAQKAQXPodAVArUJ3m2BlwCXB84EHgr8EDgOOBC4BDgcOGO9BCwvL6/u3Lmztn51ZbzYDwlIQAKdJqDgdTq9C9W52kQo4vZw4OPAq4HXA18DjgK2A3sBJwH7KHgLNU7trAQkIIGZEFDwZoLZm8yAQG2CtydwQen3CnAucH3gfODk8vWzgH2BCwfxsYI3g1HjLSQgAQl0lICC19HELmC3ahO8XgquDbwHOAA4FjgFOLV88zTgCOAcBW8BR6xdloAEJDBFAgreFOHa9EwJ1Ch4kbsI3dOBdwAnrhG804HDSnXvZ2BZwZvp+PFmEpCABDpFQMHrVDoXujO1Cd6Vi9Q9E3hryUxEL9O2u8r/nw1sAy5aWVk5enV19Zi1GdyxY8dCJ9XOS0ACEpDA1ggcuWvdZ/i21uAcrjr+kG0sLS3V9vk+BxKLfcvaBsDxwIeAV/alZb8yTXsQsDdwArD/emmzgrfYA9reS0ACEhiHgBW8ceh5bU0EahO8i9dMvUb08rDFMnAwkO8fWl6hMpCjglfT8DIWCUhAAm0RUPDaypfRrk+gNsEbO1cK3tgIbUACTRDYvvO172oi0A2CPGX5AXmQzKMiAgpeRckwlLEIKHhj4fNiCUhgXgS68EF8yvIDOvc7eF7jYVL37cK4cg3epEZD2+107peLFby2B6TRS2BYAl34IFbwhs327M7rwrhS8GY3Xmq+k4JXc3aMTQISWJdAFz6IFbz6BngXxpWCV9+4mkdECt48qHtPCUhgbAJd+CBW8MYeBhNvoAvjSsGb+LBoskEFr8m0GbQEJNCFD2IFr75x3IVxpeDVN67mEZGCNw/q3lMCEhibQBc+iBW8sYfBxBvowrhS8CY+LJpsUMFrMm0GLQEJdOGDWMGrbxx3YVwpePWNq3lEpODNg7r3lIAExibQhQ9iBW/sYTDxBrowrhS8iQ+LJhtU8JpMm0FLQAJd+CBW8Oobx10YVwpefeNqHhEpePOg7j0lIIGxCXThg1jBG3sYTLyBLowrBW/iw6LJBhW8JtNm0BKQQBc+iCN423e+5pjWs3nK8gOP6U4/Xrvaej4UvNYzOJn4FbzJcLQVCUhgxgS6I3jtC8WPRdV+zPhHYN3bKXi1ZGK+cSh48+Xv3SUggS0SUCi2CG4Klyl4U4A6RpMK3hjwOnSpgtehZNoVCSwSAQWvnmwrePXkIpEoeHXlY17RKHjzIu99JSCBsQgoeGPhm+jFCt5EcY7dmII3NsJONKDgdSKNdkICi0dAwasn5wpePbmwgldXLuYZjYI3T/reWwIS2DIBBW/L6CZ+oYI3caRjNWgFbyx8nblYwetMKu2IBBaLgIJXT74VvHpyYQWvrlzMMxoFb570vbcE5kBAMZoD9HVuqRjVk4tE0pV8WMGra1zNKxoFb17kva8E5kRAwZsT+AG37YpQ2I96xpQVvLpyMc9oFLx50vfeEpgDAQVvDtCt4NUDfYNIuiKqVvCaGG5TD1LBmzpibyCBuggoePXkoytCYT/qGVNW8OrKxTyjUfDmSd97S2AOBBS8OUC3glcPdCt4TeTCIMcnoOCNz9AWJNAUAQWvnnRZ+aonF4mkK/lwiraucTWvaBS8eZH3vhKYEwEFb07gB9y2K0JhP+oZU07R1pWLeUaj4M2TvveWwBwIKHhzgO4UbT3QnaJtIhcGOT4BBW98hrYggaYIKHj1pMvKVz25cIq2rlwYzfgEFLzxGdrCghDYvvM1x7Te1VOWH3iMgldPFhW8enKh4NWVC6MZn4CCNz5DW1gQAopRPYlWjOrJRZfEqCvjyocs6vr5mFc0rQjeccCBwCXA4cAZ6wFbXl5e3blzZyv9mlfeZ3rf7Ttf+66Z3nAKNztl+QEHKHhTALvFJrvyQWw/tjgApnRZV/Kh4E1pgDTWbAsidCfgKGA7sBdwErCPgtfOSFOM6slVVz7A7Ec9Y8oKXl25SDQKXn05mUdELQhe1j2dD5xcAJ0F7AtcOAhYKnjv++YN3z0PmJO8Z6kYWfmaJNQx2lIoxoA3hUvNxxSgjtGk+RgD3hQuVfCmALXBJlsQvBPz/kng1ML3NOAI4JwNBK/BVFw6ZH9h1pVC82E+pkHAcTUNqltvsyv5UPC2Pga6dGWLgnc6cBhw7srKytGrq6uXerLxcpe73I9+8IMfXKZLSbIvEpCABCQggWEJ7LHHHt975CMfeaVhz/e8bhJoQfCeDlwA7CopOBvYBly0XgWvCw9ZdOVhEftR1y8O82E+pkHAcTUNqltvsyv52DoBrwyBFgRvP+BY4CBgb+AEYP/10teVgW0/6voBNR/mYxoEHFfToLr1Ns3H1tl5ZX0EWhC8UFsGDgYuBg4FzlTw6htMVlTrz4kfYHXlyHyYj2kQ6Mq4mgabRWqzFcEbOiddGdj2Y+iUz+RE8zETzEPfxHwMjWomJ5qPmWAe+iZdycfQHfbEgQQ6J3h58OKoo456Ruv5th91ZdB8mI9pEHBcTYPq1ts0H1tn55X1Eeic4NWH2IgkIAEJSEACEpDAbAkoeLPl7d0kIAEJSEACEpDA1Al0VfDyHrw8efsIYM8+ikPvaTt18pe+QfLwAiDbsv0IeDyQXSxuCbwMuDzwgbIP74xDG+l2VyxbyWVLuRxHA//UYD96nb4K8KnyYu28bLu1fNwGyHsjv1Q69O/AwxvsR8J/YBlP+Vl5HPAvDfYj7+9M7L3jRsAewA0b+zm/XNlZKL9b86615zT6c/7z5fVbvwV8B/hj4DMVjav7Aa8orwXL68FyrPc7qNbPtpE+QDx5sgS6KnhPKj+wTwGuX5CNtKftZDFv2to9gIcBvw/cBHg98JvAO4GdwAeB15Vfqvlgq/XIL6RblQ/iXwGyZdxSg/3o8X0ucBcgazojeK3l4wDg/uXF4P1jprV+XBuInN4OuHJ5qv4hDeajPwc3B54F5GemtXzk91ReW5U3GiQ3+f3U4s95/mjI2xkeWvY3z+fFvSvJx+2BQ4AbA48CeoI3aKx8e5T92mv98DCuyRPoquCl8pJB//k+wRtpT9vJo96wxXxo5a/ibwG9qlF+YeaHOv/OkQ/qfMA9ccaxbfV2dwSeDfxOo/24BfBU4DzgfcDbGuzHvUpVOH/w9I6Ms9bG1R+Usd96P/p/lt4IPA34rwbzkT8csl3kjlJ9/EfgDg32Iy/R/0KZdUhusud5Lb93e59h2Zrz0YXtej+7een/0Pu1b/UXute1R6CrgtfLRL/gjbSn7RxT+WdF8jJlm6pRdu3IkZc755fqH84xtmFvnWnNqwN3K9ODrfUjPxf/XP6Czi/XCN4ZDebjQeXDIdP+lwX+tAhFa/mI2KUifD3gF4F8MEdSW+tH7+fnN4DnAduB6zbaj9cCmdq8FhABz898a/lI9TRVvMSfGZMPATcDXlPR791+wVtvrKQwMPR+7cP+Eve89gkssuD9ZE/bitKYNYO/V6YJ8ouz/xdmKmJZw/NHFcW7USipNp4EHNhgP7JOLfyzriUv2R4keC3kI1XIyMQbytqdtwD7Am/u+wBroR8RvFSC7wn8clmfmh1uWv35iNy9F3jTAMFrIR8R0/yhmd9FvwqcWn7OM756f5C20I+s1c76wfxM5A+49Ct/lPYL3rz7sZHg9WK7cI3g1fjZ1sjHVrfCXCTBG2lP2zmkOb8s80szgvc9IAuAzwWyEDtH/tLMovn+aao5hLnhLW8NfL1Ma+bEs8oHc9ZPtdSPrIFMxSiVr/w7UyBZp5Nf/C31Y22yPgxk2jZy0VI/HlzWIuWhnRz/CWTd6vsb60cvH58sUpFx1eLP+V+WCmoeAMjxEeDuZZ1kS+Oq/+cjD7J9Gvi1yn7v9gveemMlgjf0fu21fWgYz/QILJLgjbSn7fSQD2w5U09Zk3Nn4Lt9Z7wdeGb5QM7TqJm2zQ98rceflGmbLA5On/Lk7w2AtzbWj36+vQpeqkWt5SN5uAaQh0VSaXlPWWPUWj5+qTx4lAderllEIg8jZV1kSz8fGVeJ/9+APGTRO1obV5lpyPTsY8r4+mgZV3kArKV87FP+cDu8PEGbtYV52K2mfPQLXsbLoNjyBPDQ+7XX+uFhXJMn0FXB2wXkKaRMT2UR898DfzHKnraTR71hi1l3l1ejfKXvrMSf6lGmOa9Qnkh9wozjGvV2iTOvdcl6lkx/5Km0TNvkw6ylfqwneK31I+sgX12mNdOno4B3NJqPyGqe2sxawjz8kmnB1vKRHOQVQi8EIhO9o7V+5Oc8v2PzR1z+O39A5A/Q1vqRsZTPhpsCXywzKN+opB95cvax5SGWxJaq7303iG3o/dpH/aXu+e0S6KrgtZsRI5eABCQgAQlIQAJjElDwxgTo5RKQgAQkIAEJSKA2AgpebRkxHglIQAISkIAEJDAmAQVvTIBeLgEJSEACEpCABGojoODVlhHjkYAEJCABCUhAAmMSUPDGBOjlEpCABCQgAQlIoDYCCl5tGTEeCUhAAhKQgAQkMCYBBW9MgF4uAQlIQAISkIAEaiOg4NWWEeMZl0D2jb1DaSRbjf1P2VP2xeM2PMb1vw+cA3xshDby0tjsGXud8tLuvOh0nKM/hrwoODsOXKlsi7eVdrNl3t8A2SZpEsf+ZceW7AWanTbGjTc7eOSltX9a8r9ejHuUF9yeMEInrly24cvODXmRdLZ+68Xd30x2IfiFsi3ZCM2PfOp9yk442Qc2uc2uJfnvH47ckhdIQAKdIaDgdSaVdqQQiODlDfvZcuhyQN4IH1mI9GVP3HkcnwOyW8mrRrh5BCo7BGSbri+PcN16p/bHkB0usmVW5Hd1C23fuOzXmZ1WPr+F6wddkh0R9ix9zXZ9/fFuRUiHFbxHAjvLXrfDdiU7gmRf3OuXnQXWE7zrlh1dsk/oNI9+wYtwnw08BHjlNG9q2xKQQN0EFLy682N0oxOI4OXD/Rbl0luWyln2zcx2aS8C7g1k/8ZUbSJRxwDZBi7f/92yndQdgb8u2xh9vIhi/n1Q+XqqJB8uIvnfZSu575WK1nbgjHKfD5V9OhNOJC9bCvWOCGg2bn8AcBXgX4EjSvUlexP3jr2B7PeZI1vApTLz2tJutuNLFSn7AKe99O9+5bx8Pf0+d00M2bS8V8HL74BBTLLv67vKdnOJKdW+SGeqUpGv3pEt9fJP+KUalipl9ir9RN852eszLK9W4jirbGF3L+DRwLOAe5b+pxKWrbyWyvVh1ou3d+7/AjvKJvf9I+S2wN8V8UrFNiLWq+Bl26fEf20gY+SPgLv2SdDFJb5B/NZKcKqxyesfAr3KY8bRA4FsWp+YTy6sehW8jLEnlr5mC7+vlj4kr8ln+pw/QpLPiFmY5QjXXHfFwixfjwA/HHh2EfSMld64SVwZR5cAvz36j49XSEACXSGg4HUlk/ajR6AneNkMPWKQD/XIzIHAnct+ptkP9AblQzpTWfmgz2bdka1IXvYEjrRFZvJh/bdFwA4uX39eEbV/LFIVocu5kcL8c9Xy//nQzdcjBPlAjnz0T5sltpUyvZdq2ulF5CI+kYDEHWn6+ppKWz68s8dyNkuPVGSqNP2LNOSe+f9IbtrL189fE0P61BO83Cd7vK5lEqFIZSp9TJUrEhFZTlUq+8LmHqnkfQ34ZhHMiMmfl8rgiX1D8mZlSvN2QCQs19+w9C1MwiuC1KuEfWZAvMnPcWX69k1Apkfvv2bYf7D0O2LzoJLPCF6kLTl7T9mLN7mN3KcK9wpgv1KJi1wN4heOvSOCmD5HqCORPcHLXqyRyNwr90/lNcx6gterQj6uMI0Iv7P0IflMn+9U2n1aiScVzdw74zZ/XEQGX1Dk8Qtl/9cIfPaFzR8tGcsRvOQ2Yyt/NGSZgocEJLCABBS8BUx6x7vcvwav19V8EOcDOVO0kYz/K9/ItGCqI9cqH4pZ7xZJ6n1oZ+orH9y9I9W9twHfLhWSbFZ+EfDLReTy4Z9qW44fFGmJCEUoHjxgijYf3hG4W5VrXlKm1rLGK9WnCGfkpxdvL44IwfEl9khANiPP+akavRT4zXL/iNVDi9j0x9A/5RnJGMQkAhLh6jHoXRNmqVxFejNFm3tHNtP3VPzCJ6KXKlP/8aXCOBKTPERAIsavL9WriElP8DLFOCjesEr1LjFHQCNmvSOVze8DEctIzy8WUY/gRe4ikKkSpsoaLqluZhr/5SXfkdW0P4hfJLB3RIRTnczG7xHNtWMllcFMxUe+/2KA4EW8v1XGS/KcPiSfEbfH97WXPyZSRY2M5/wcqdC+pfTx3WXpQfilmhkR7wleqnwZ8z1eHf+Rt3sSkMAgAgqe46JrBCJ4qZ5k2jPVi8+WClP6GTHI2rOehPX6vnaNVyom+QDtfYhHajJFGXFKFWit+KWdtQvqIxLPByJtwwpeZDCVp1ReNhO8nhBEslKhi8hE9vLhnq+l0pYHMyIx6ct6gvfP6zBZ+9BD1qlFOMMhbHuClzV4mXrNtPABhU3ul4pS//EPRa4iyamYpn+ZOn56Edy0sZng9R4KyUMYEaV9NxC8jIGsfQuXCGgeWLl7qfylQpt+R377BS8iOIhfzukdmfpPNW2t4KW/uUfyF8GNbGU6fm0Fb1AfInipToZx+vT+UtWNeD+j9LUneYmjNz6ztjSCl3y8ZoDgRbpT/fWQgAQWkICCt4BJ73iX167B6+9upuQic/mAjFBELjL9GDnpf6o038uU6TuKIOQDO9W9VGXy9bcDRxbhiSw8eQPBy9qqrFlLNSdrprL2r3f0pmhTrUklLJKY6lY+uHtCtV4FL3FkPWCEIhKQyliEJdOWWb8WgcqUYdZwvWFNDPlar785bxCTVDX7Hx7oF7zEFyYRpvOKyIRlpqJTOQqnPAXcf0ScIjyRmVSWMi2ctXc5Um3L+rPe/VIh62fWH2/EeZDgpZ1UASPwmZYOi8QUwctDKpkKzvq+8EzsEbzk/WWlAhZxyzq5Qfz6n7Bdb4o2jLNGMNOlmaZPVTfV33EEL1XQyHKqzKkW9iq0GX8ZL6eUamWWJf1JOwAAAgZJREFUFUSanaLt+C83uyeBUQgoeKPQ8twWCGwkeKmM9R4oyKL6fHBHvAY9pRlJSAXuRmXtUwQl05b5IE2lJ2vIPlLW1kVs1qvgZY1bKod5ECHCkTV3vSML8lMVyzq6VAnTRiQh08SbCd7rypq4VOvyAR8JujXw/4rkRGxSLct6vlQsM3XZiyFTfT3ByzTzICYbVfBSHcxC/ohaJO/3yrRtZOZTZaoxYtJ/3LR8L6KS6ldvqjMVqAhj//0iMP3M+uPdSPAy3RmRS54j1hHI8I90nlr4ZPo0ApmKWXIa1vlapnfTlzy8Ekns55f1nJk27h3Jdx6iyXRsqpaJNfKadZZZYxlx//s1Y2LtGOuX1PUqeDknfzzkj4mwTR/yB0n+SMiSgwhpXgWTtX45L/1P9S9V5sThQxYt/MYyRglMiYCCNyWwNiuBKRLoF4Ip3sam1yEQ+Y6s5zUptU2B/nqR0UzN968dNJkSkMCCEVDwFizhdrcTBBS8+aYxFcKsb0yF7bD5hvIzd0+FNE+I52llX3RcWXIMRwKzJKDgzZK295KABCQgAQlIQAIzIKDgzQCyt5CABCQgAQlIQAKzJKDgzZK295KABCQgAQlIQAIzIKDgzQCyt5CABCQgAQlIQAKzJKDgzZK295KABCQgAQlIQAIzIKDgzQCyt5CABCQgAQlIQAKzJPD/AQg23YwHmXP/AAAAAElFTkSuQmCC"
     },
     "metadata": {
      "jupyter-vega3": "#840f1fc3-1c79-4e9d-840d-3569e5ae53a7"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df[['data completion']].vgplot.hist(bins=10,\n",
    "                                    var_name='Number of hospitals',\n",
    "                                    value_name='Percent of patients with data')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As we can see, the majority of hospitals collect APACHE data."
   ]
  }
 ],
 "metadata": {
  "front-matter": {
   "date": "2015-09-01",
   "linktitle": "admissiondrug",
   "title": "admissiondrug"
  },
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
